package com.tszs.dao.mapper;

import com.tszs.entity.CommodityList;
import com.tszs.entity.CommodityListExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface CommodityListMapper {
	
	
	
	
	@Select("select count(c_id) from commodity_list where c_static in (1,0)")
	int countNum();
	
	
	/**
	 * 统计已经下架的商品
	 * @author MRC
	 * @date 2019年5月28日下午2:59:46
	 * @return
	 */
	@Select("select count(c_id) from commodity_list where c_static =1")
	int countUndercarriage();
	
	
	
	CommodityList findById(@Param("id")String id);
	
	/**
	 * This method was generated by MyBatis Generator. This method corresponds to the database table commodity_list
	 * @mbggenerated  Wed Apr 24 15:14:02 CST 2019
	 */
	int countByExample(CommodityListExample example);
	/**
	 * This method was generated by MyBatis Generator. This method corresponds to the database table commodity_list
	 * @mbggenerated  Wed Apr 24 15:14:02 CST 2019
	 */
	int deleteByExample(CommodityListExample example);
	/**
	 * This method was generated by MyBatis Generator. This method corresponds to the database table commodity_list
	 * @mbggenerated  Wed Apr 24 15:14:02 CST 2019
	 */
	int insert(CommodityList record);
	/**
	 * This method was generated by MyBatis Generator. This method corresponds to the database table commodity_list
	 * @mbggenerated  Wed Apr 24 15:14:02 CST 2019
	 */
	int insertSelective(CommodityList record);
	/**
	 * This method was generated by MyBatis Generator. This method corresponds to the database table commodity_list
	 * @mbggenerated  Wed Apr 24 15:14:02 CST 2019
	 */
	List<CommodityList> selectByExample(CommodityListExample example);
	/**
	 * This method was generated by MyBatis Generator. This method corresponds to the database table commodity_list
	 * @mbggenerated  Wed Apr 24 15:14:02 CST 2019
	 */
	int updateByExampleSelective(@Param("record") CommodityList record, @Param("example") CommodityListExample example);
	/**
	 * This method was generated by MyBatis Generator. This method corresponds to the database table commodity_list
	 * @mbggenerated  Wed Apr 24 15:14:02 CST 2019
	 */
	int updateByExample(@Param("record") CommodityList record, @Param("example") CommodityListExample example);
	List<CommodityList>  selectByIdName(CommodityList example);
	List<CommodityList>findprice(CommodityList example);
	List<CommodityList>findcPhtoto(CommodityList example);
	List<CommodityList>titleShowall(CommodityList example);
	List<CommodityList> selectByExamplePage(CommodityList example);

	List<CommodityList> selectByExamplePage2(CommodityList example);

	List<CommodityList> selectAall(CommodityList example);
	
	List<CommodityList>titleShow(CommodityList example);

	List<CommodityList> Showdatails(CommodityList example);
	List<CommodityList> titleShowshopDatails(CommodityList example);
}